For SQL environments, prepare the SQL schema before configuring the connection details.

For LDAP environments, see Configure SafeNet Synchronization Agent for LDAP.

1. From an administrator account on a Windows computer, launch SafeNet Synchronization Agent by clicking Start > SafeNet > SafeNet Synchronization Agent. If necessary, right-click SafeNet Synchronization Agent and select Run as administrator.

   The SafeNet Synchronization Agent window displays.

   

2. Click Add in the SafeNet Virtual Server section.

3. Browse to the location of the SASSyncConfigFile.bmc key file saved in step 3 of Configure record removal and generate an encryption key and then select Open to load the file.

   The Virtual Server Name field displays the name of your virtual server.

4. Click the Configuration tab.

5. Click Configure in the SQL Schema Configuration section.

   

   The SQL Schema Management window displays.

6. Enter a name in the Mapping Schema Name field and then click Add to add a schema.

   

   Five SQL statements are included in the sample user source schema:

   • Single User

   • User List

   • Groups

   • User's Groups

   • Group's Membership

   The number of each statement is displayed at the bottom left of the window.

   

   SafeNet Synchronization Agent uses null padding for binary values. On MySQL, use the BINARY data type instead of VARBINARY for your SQL queries.

7. In each SQL statement window:

   1. After the word SELECT in the SQL Statement box, replace each default field name with the corresponding field name used in your SQL environment. Ensure that all of the fields in the edited statement are listed in the same order as in the default statement.

      For PostgreSQL, you must declare mixed-case SQL attributes with double-quotes. For example:
      SELECT "UserID", "userName", "firstName", "lastName", email, phonenumber, cellnumber, extension, address, city, province, postal, country FROM users

   2. Under Filter Columns, replace each default field name with the corresponding field name used in your SQL environment.

      For PostgreSQL, enclose mixed-case field names in double-quotes.

   3. Click Apply to save your changes.

   4. Click Next or Previous to move through the statements.

8. Click OK, after the field names in all five SQL statements comply with the field names used in your SQL environment.

9. Click the Configuration tab in the SafeNet Virtual Server section.

10. Click Configure** in the User Source Configuration section.

    

    The User Source Type window displays.

    

11. Select SQL and then click Next.

    The Database Provider window displays.

    

12. Select the appropriate database provider and then click Next.

13. Enter the configuration settings for your SQL database. See the examples which follow.

    • For PostgreSQL: The database name must be in lowercase (and must already exist, but can be empty). If the database was created with uppercase in the name, it must be renamed.

      

    • For MySQL: If the .NET Connector is not present, the system will prompt you to install it.

      

    • For MS SQL: Enter the user name and password created for the STA Synchronization Agent connection to the LDAP directory server.

      

    • For Oracle:

      

14. Click Next after completing the configuration settings for your SQL database.

    Depending on your SQL settings, you may be prompted to enter one or more failover hosts or servers for the agent to connect to in the event that the primary SQL server is inaccessible.

    

    The Database Found window displays.

    

15. Click Next.

    The Custom SQL Mapping window displays.

16. Select the SQL schema that you defined previously (see step 6) and then click Next.

    The Configuration Complete window displays.

17. Click Finish to save your changes.

18. Click the Status tab in the SafeNet Virtual Server section.

19. Click Details in the Synchronization Details section to display the SQL connection information.

    The User Source Connection Details window displays.

    

    Password information is not displayed.

20. Click OK.

    SafeNet Synchronization Agent is now configured for SQL.

    Next, configure the SQL group memberships that will be used to determine which users are synchronized. See Configure groups for synchronization.